| Author |
Thread Statistics | Show CCP posts - 2 post(s) |
Jercy Fravowitz
School of Applied Knowledge
   |
Posted - 2009.12.22 17:18:00 -
[1]
usual barrage of conversions:
mysql singlefile (you are most likely looking for this one)
this one should also load just fine in php-webloader-scripts, if it whines about something with timestamps at the end, ignore it.
sqlite singlefile
postgres singlefile
sqlite "EVE Asset Manager" edition
less popular:
MSsql script dump (useful for those who cba to upgrade to sql server 2008)
xml "one file per table" dumps
mysql "one file per table" dumps
mysql "one file per table" dumps as tarball
there may or may not be other flavors i forgot about if you look here.
as usual, whine on #eve-dev on irc.coldfront.net or at me ingame if there are any issues or you need custom dumps (partial sqlite, csv, ...) or something...
|
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2009.12.23 11:50:00 -
[2]
 Originally by: Barrington Farquharsen
Database seems to be missing Elite Scorpion Lai Dai from invTypes.
not sure what that is.
if it is some random NPC encountered in missions, they can have mission-specific names, so you would have to figure out what the actual typeName of the ship named "this missions main shootme" is.
but in general it is not all that useful.
did you file a bugreport about the inconsistent naming of the citadel torp types? whats the BR-ID?
|
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2009.12.23 14:10:00 -
[3]
Originally by: Catari Taga
Originally by: Jercy Fravowitz
Originally by: Barrington Farquharsen
Database seems to be missing Elite Scorpion Lai Dai from invTypes.
not sure what that is.
Wasn't that the old name for the Widow (before release)?
very much correct, that.
mysql> select old.typeID,old.typeName as oldName,new.typeName as newName from rev220.invTypes old, dom100.invTypes new where old.typeID=new.typeID and old.typeName like '%Elite Scorpion%';
| typeID | oldName | newName |
| 22436 | Elite Scorpion Lai Dai | Widow |
| 22437 | Elite Scorpion Lai Dai Blueprint | Widow Blueprint |
it got renamed between revelations and trinity, so in late 2007.
so why would anyone care about unpublished names that got replaced two years ago?
|
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2010.01.04 17:25:00 -
[4]
Originally by: Anita Lazarin
Any have the dump in an xls format ?
sure. what parts do you want? (and what for, if i may ask?)
if you give me a list of table names i can dump those out in a xls-compatible csv format just fine.
|
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2010.01.06 17:44:00 -
[5]
Originally by: Anita Lazarin
For manufacturing so I believe its just the item database so I can look up a bpo and get its base values ?
dom103 static data dump in one-file-per-table format that excel should be able to import: excel-csv
And good luck. You are going to need it.
|
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2010.01.06 17:56:00 -
[6]
Originally by: CrashM
So is there an image dump that actually contains all the "types" images.
By that i mean ores and minerals and similar such items.
Do you have any example of something you are actualy missing?
only checked Veld and Trit, but those are in there just fine ...
finding the images is a two-step process:
a) check if there is an image with the typeID as filename. if not,
b) do a invTypes.graphicID->eveGraphics.icon lookup, then look for that name.
mysql> select typeID,typeName,graphicID from invTypes where typeName='Dense Veldspar';
| typeID | typeName | graphicID |
| 17471 | Dense Veldspar | 232 |
> find Dominion_1.0.0_imgs -name "*17471*"
>
mysql> select graphicID,icon from eveGraphics where graphicID=232;
| graphicID | icon |
| 232 | 24_01 |
> find Dominion_1.0.0_imgs/icons -name "*24_01*"
Dominion_1.0.0_imgs/icons/32_32/icon24_01.png
Dominion_1.0.0_imgs/icons/16_16/icon24_01.png
Dominion_1.0.0_imgs/icons/64_64/icon24_01.png
>
|
| |
|